<html>
<head>
<style>
</style>
<script type="text/javascript">
	var tableToExcel = (function() {
		var uri = 'data:application/vnd.ms-excel;base64,', template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>', base64 = function(
				s) {
			return window.btoa(unescape(encodeURIComponent(s)))
		}, format = function(s, c) {
			return s.replace(/{(\w+)}/g, function(m, p) {
				return c[p];
			})
		};
		return function(table, name, filename) {
			if (!table.nodeType)
				table = document.getElementById(table)
			var ctx = {
				worksheet : name || 'Worksheet',
				table : table.innerHTML
			}

			document.getElementById("dlink").href = uri
					+ base64(format(template, ctx));
			document.getElementById("dlink").download = filename;
			document.getElementById("dlink").click();
		}
	})()
</script>
<script type="text/javascript">
	var timer;
	function getExplorer() {//获取浏览器
		var explorer = window.navigator.userAgent;
		if (explorer.indexOf("MSIE") >= 0
				|| (explorer.indexOf("Windows NT 6.1;") >= 0 && explorer
						.indexOf("Trident/7.0;") >= 0)) {
			return 'ie';
		} else if (explorer.indexOf("Firefox") >= 0) {
			return 'Firefox';
		} else if (explorer.indexOf("Chrome") >= 0) {
			return 'Chrome';
		} else if (explorer.indexOf("Opera") >= 0) {
			return 'Opera';
		} else if (explorer.indexOf("Safari") >= 0) {
			return 'Safari';
		}
	}
	function excels(table) {
		if (getExplorer() == 'ie') {
			var curTbl = document.getElementById(table);
			var oXl = new ActiveXObject("Excel.Application");//创建AX对象excel 
			var oWB = oXL.Workbooks.Add();//获取workbook对象
			var xlsheet = oWB.Worksheets(1);//激活当前sheet
			var sel = document.body.createTextRange();
			sel.moveToElementText(curTbl);//把表格中的内容移到TextRange中 
			sel.select;//全选TextRange中内容
			sel.execCommand("Copy");//复制TextRange中内容
			xlsheet.Paste();//粘贴到活动的EXCEL中
			oXL.Visible = true;//设置excel可见属性
			try {
				var filename = oXL.Application.GetSaveAsFilename("Excel.xls",
						"Excel Spreadsheets (*.xls), *.xls");
			} catch (e) {
				window.print("Nested catch caught " + e);
			} finally {
				oWB.SaveAs(filename);
				oWB.Close(savechanges = false);
				oXL.Quit();
				oXL = null;//结束excel进程，退出完成
				timer = window.setInterval("Cleanup();", 1);
			}
		} else {
			tableToExcel("tables");
		}
	}
	function Cleanup() {
		window.clearInterval(timer);
		CollectGarbage();//CollectGarbage,是IE的一个特有属性,用于释放内存的
	}
	var tableToExcel = (function() {
		var uri = 'data:application/vnd.ms-excel;base64,', template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>', base64 = function(
				s) {
			return window.btoa(unescape(encodeURIComponent(s)))
		}, format = function(s, c) {
			return s.replace(/{(\w+)}/g, function(m, p) {
				return c[p];
			})
		};
		return function(table, name) {
			if (!table.nodeType)
				table = document.getElementById(table);
			var ctx = {
				worksheet : name || 'Worksheet',
				table : table.innerHTML
			};
			window.location.href = uri + base64(format(template, ctx))
		}
	})();
</script>
</head>
<body>
	<table class="table tableStyles" id="tables">
		<caption>不正经的统计表</caption>
		<!--可以生成表格的标题-->
		<thead>
			<tr>
				<th>品牌</th>
				<th>门店</th>
				<th>本周回访</th>
				<th>本月回访</th>
				<th>总回访</th>
				<th>本周成交数</th>
				<th>本月成交数</th>
				<th>总成交数</th>
				<th>异常量</th>
				<th>成交转化率</th>
				<th>经手人</th>
			</tr>
		</thead>
		<tbody>
			<tr>
				<td rowspan="3">华为</td>
				<td>华为深圳店</td>
				<td>20</td>
				<td>80</td>
				<td>500</td>
				<td>1</td>
				<td>3</td>
				<td>20</td>
				<td>1</td>
				<td>4.0%</td>
				<td>黄生</td>
			</tr>
			<tr>
				<td>华为东莞店</td>
				<td colspan="2" rowspan="2"
					style="text-align: center; vertical-align: middle;"><span
					style="font-size: 16px;">666666</span></td>
				<!-- <td>80</td> -->
				<td>500</td>
				<td>1</td>
				<td>3</td>
				<td>20</td>
				<td>1</td>
				<td>4.0%</td>
				<td>黄生</td>
			</tr>
			<tr>
				<td>华为佛山店</td>
				<!-- <td>20</td> -->
				<!--  <td>80</td> -->
				<td>500</td>
				<td>1</td>
				<td>3</td>
				<td>20</td>
				<td>1</td>
				<td>4.0%</td>
				<td>黄生</td>
			</tr>
			<tr>
				<td rowspan="3">小米</td>
				<td>米家深圳店</td>
				<td>20</td>
				<td>80</td>
				<td>500</td>
				<td>1</td>
				<td>3</td>
				<td>20</td>
				<td>1</td>
				<td>4.0%</td>
				<td>林生</td>
			</tr>
		</tbody>
	</table>
	<a id="dlink" style="display: none;"></a>
	<input type="button"
		onclick="tableToExcel('tables', 'name', 'myfile.xls')"
		value="Export to Excel">
	<input id="Button1" type="button" value="导出EXCEL"
		onclick="javascript:excels('tables')" />
</body>

</html>